How to Consume a Data Export

Use a Data Export link to fetch data from Visier to a third-party tool or web application.

Who can use this feature?

Users with this permission capability:

  • Consume Data Exports

Not sure if you have this feature or capability? Reach out to your administrator.

Overview

You can use the following third-party tools and web applications to fetch data from Visier.

Note:  

  • When downloading data as a spreadsheet or consuming a Data Export, null (N/A) values in the visual will appear as blank (empty) cells in the destination.

  • When consuming an Aggregated Data Export, you may notice differences in how the data is structured in Visier and your third-party tool or web application:

    • Hierarchy structures will not be preserved when you consume the Aggregated Data Export.

      For example, your Aggregated Data Export includes the Location Hierarchy grouping. You can expand and collapse these rows to drill down to view data at the Region, Country, or State levels in Visier.

    • The hierarchical information used to show the relationship between data will not be included in the export. As a result, attribute members of the hierarchy will appear in a single column in the third-party application, as shown in the following screenshot.

    • Columns that contain mixed data types will be exported as strings. For example, if a column in the Aggregated Data Export contains strings (Exceptional, Good, Poor) and numbers (10.3% 39.0%, 89.7%). The data type for this column in the third-party application will be string.
    • Currency codes and percentage symbols will not be included when you consume the Aggregated Data Export.

      For example, the currency codes and percentage symbols appear alongside the amount in the Aggregated Data Export.

      However, you will only see the amount in the third-party application, as shown in the following screenshot.

In this section